{__NOLAYOUT__}
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>数据字典生成</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" type="text/css" media="screen" href="/static/create.table/css/main.css" />
</head>
<body>
    <div id="main">
        <div class="title">
            <h2>{$database}数据字典</h2>
            <p>生成时间：{$create_time}</p>
        </div>
        <div class="items">
            {volist  name="record" id="r"}
            <div class="item">
                <div class="label">
                    <h4>表名：{$r.TABLE_NAME}</h4>
                </div>
                <div class="table">
                    <table class="field_des">
                        <thead>
                            <tr>
                                <th width="15%">字段名</th>
                                <th width="18%">类型</th>
                                <th width="8%">默认值</th>
                                <th width="6%">允许为空</th>
                                <th width="10%">表字符集</th>
                                <th width="10%">校验字符集</th>
                                <th width="5%">自增键</th>
                                <th width="5%">主键</th>
                                <th class="last">备注</dt>
                            </tr>
                        </thead>
                        <tbody>
                            {volist name="r.cols" id="vo"}
                            <tr>
                                <td>{$vo.COLUMN_NAME}</td>
                                <td>{$vo.COLUMN_TYPE}</td>
                                <td>{$vo.COLUMN_DEFAULT}</td>
                                <td>{$vo.IS_NULLABLE}</td>
                                <td>{$vo.CHARACTER_SET_NAME}</td>
                                <td>{$vo.COLLATION_NAME}</td>
                                <td>{$vo.IS_AUTO_INCREMENT}</td>
                                <td>{$vo.IS_PRI}</td>
                                <td class="last">{$vo.COLUMN_COMMENT}</td>
                            </tr>
                            {/volist}
                        </tbody>
                        <tfoot>
                            <tr>
                                <td>索引</td>
                                <td  colspan="8">
                                    {volist name="r.index" id="vo"}
                                    <p><b>{$vo.INDEX}：</b>`{$vo.INDEX_NAME}`({$vo.COLUMN_NAME})</p>
                                    {/volist}
                                </td>
                            </tr>
                            <tr>
                                <td>引擎</td>
                                <td>{$r.ENGINE}</td>
                                <td>字符编码</td>
                                <td colspan="2">{$r.TABLE_COLLATION}</td>
                                <td>备注</td>
                                <td colspan="3">{$r.TABLE_COMMENT}</td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
            {/volist}
        </div>
    </div>
</body>
</html>